package com.kgc.travel.pojo;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class CertificateExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public CertificateExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andCertificateIdIsNull() {
            addCriterion("certificate_id is null");
            return (Criteria) this;
        }

        public Criteria andCertificateIdIsNotNull() {
            addCriterion("certificate_id is not null");
            return (Criteria) this;
        }

        public Criteria andCertificateIdEqualTo(Integer value) {
            addCriterion("certificate_id =", value, "certificateId");
            return (Criteria) this;
        }

        public Criteria andCertificateIdNotEqualTo(Integer value) {
            addCriterion("certificate_id <>", value, "certificateId");
            return (Criteria) this;
        }

        public Criteria andCertificateIdGreaterThan(Integer value) {
            addCriterion("certificate_id >", value, "certificateId");
            return (Criteria) this;
        }

        public Criteria andCertificateIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("certificate_id >=", value, "certificateId");
            return (Criteria) this;
        }

        public Criteria andCertificateIdLessThan(Integer value) {
            addCriterion("certificate_id <", value, "certificateId");
            return (Criteria) this;
        }

        public Criteria andCertificateIdLessThanOrEqualTo(Integer value) {
            addCriterion("certificate_id <=", value, "certificateId");
            return (Criteria) this;
        }

        public Criteria andCertificateIdIn(List<Integer> values) {
            addCriterion("certificate_id in", values, "certificateId");
            return (Criteria) this;
        }

        public Criteria andCertificateIdNotIn(List<Integer> values) {
            addCriterion("certificate_id not in", values, "certificateId");
            return (Criteria) this;
        }

        public Criteria andCertificateIdBetween(Integer value1, Integer value2) {
            addCriterion("certificate_id between", value1, value2, "certificateId");
            return (Criteria) this;
        }

        public Criteria andCertificateIdNotBetween(Integer value1, Integer value2) {
            addCriterion("certificate_id not between", value1, value2, "certificateId");
            return (Criteria) this;
        }

        public Criteria andCertificateInfoIdIsNull() {
            addCriterion("certificate_info_id is null");
            return (Criteria) this;
        }

        public Criteria andCertificateInfoIdIsNotNull() {
            addCriterion("certificate_info_id is not null");
            return (Criteria) this;
        }

        public Criteria andCertificateInfoIdEqualTo(Integer value) {
            addCriterion("certificate_info_id =", value, "certificateInfoId");
            return (Criteria) this;
        }

        public Criteria andCertificateInfoIdNotEqualTo(Integer value) {
            addCriterion("certificate_info_id <>", value, "certificateInfoId");
            return (Criteria) this;
        }

        public Criteria andCertificateInfoIdGreaterThan(Integer value) {
            addCriterion("certificate_info_id >", value, "certificateInfoId");
            return (Criteria) this;
        }

        public Criteria andCertificateInfoIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("certificate_info_id >=", value, "certificateInfoId");
            return (Criteria) this;
        }

        public Criteria andCertificateInfoIdLessThan(Integer value) {
            addCriterion("certificate_info_id <", value, "certificateInfoId");
            return (Criteria) this;
        }

        public Criteria andCertificateInfoIdLessThanOrEqualTo(Integer value) {
            addCriterion("certificate_info_id <=", value, "certificateInfoId");
            return (Criteria) this;
        }

        public Criteria andCertificateInfoIdIn(List<Integer> values) {
            addCriterion("certificate_info_id in", values, "certificateInfoId");
            return (Criteria) this;
        }

        public Criteria andCertificateInfoIdNotIn(List<Integer> values) {
            addCriterion("certificate_info_id not in", values, "certificateInfoId");
            return (Criteria) this;
        }

        public Criteria andCertificateInfoIdBetween(Integer value1, Integer value2) {
            addCriterion("certificate_info_id between", value1, value2, "certificateInfoId");
            return (Criteria) this;
        }

        public Criteria andCertificateInfoIdNotBetween(Integer value1, Integer value2) {
            addCriterion("certificate_info_id not between", value1, value2, "certificateInfoId");
            return (Criteria) this;
        }

        public Criteria andCertificateGmtCreateIsNull() {
            addCriterion("certificate_gmt_create is null");
            return (Criteria) this;
        }

        public Criteria andCertificateGmtCreateIsNotNull() {
            addCriterion("certificate_gmt_create is not null");
            return (Criteria) this;
        }

        public Criteria andCertificateGmtCreateEqualTo(Date value) {
            addCriterion("certificate_gmt_create =", value, "certificateGmtCreate");
            return (Criteria) this;
        }

        public Criteria andCertificateGmtCreateNotEqualTo(Date value) {
            addCriterion("certificate_gmt_create <>", value, "certificateGmtCreate");
            return (Criteria) this;
        }

        public Criteria andCertificateGmtCreateGreaterThan(Date value) {
            addCriterion("certificate_gmt_create >", value, "certificateGmtCreate");
            return (Criteria) this;
        }

        public Criteria andCertificateGmtCreateGreaterThanOrEqualTo(Date value) {
            addCriterion("certificate_gmt_create >=", value, "certificateGmtCreate");
            return (Criteria) this;
        }

        public Criteria andCertificateGmtCreateLessThan(Date value) {
            addCriterion("certificate_gmt_create <", value, "certificateGmtCreate");
            return (Criteria) this;
        }

        public Criteria andCertificateGmtCreateLessThanOrEqualTo(Date value) {
            addCriterion("certificate_gmt_create <=", value, "certificateGmtCreate");
            return (Criteria) this;
        }

        public Criteria andCertificateGmtCreateIn(List<Date> values) {
            addCriterion("certificate_gmt_create in", values, "certificateGmtCreate");
            return (Criteria) this;
        }

        public Criteria andCertificateGmtCreateNotIn(List<Date> values) {
            addCriterion("certificate_gmt_create not in", values, "certificateGmtCreate");
            return (Criteria) this;
        }

        public Criteria andCertificateGmtCreateBetween(Date value1, Date value2) {
            addCriterion("certificate_gmt_create between", value1, value2, "certificateGmtCreate");
            return (Criteria) this;
        }

        public Criteria andCertificateGmtCreateNotBetween(Date value1, Date value2) {
            addCriterion("certificate_gmt_create not between", value1, value2, "certificateGmtCreate");
            return (Criteria) this;
        }

        public Criteria andCertificateGmtModifiedIsNull() {
            addCriterion("certificate_gmt_modified is null");
            return (Criteria) this;
        }

        public Criteria andCertificateGmtModifiedIsNotNull() {
            addCriterion("certificate_gmt_modified is not null");
            return (Criteria) this;
        }

        public Criteria andCertificateGmtModifiedEqualTo(Date value) {
            addCriterion("certificate_gmt_modified =", value, "certificateGmtModified");
            return (Criteria) this;
        }

        public Criteria andCertificateGmtModifiedNotEqualTo(Date value) {
            addCriterion("certificate_gmt_modified <>", value, "certificateGmtModified");
            return (Criteria) this;
        }

        public Criteria andCertificateGmtModifiedGreaterThan(Date value) {
            addCriterion("certificate_gmt_modified >", value, "certificateGmtModified");
            return (Criteria) this;
        }

        public Criteria andCertificateGmtModifiedGreaterThanOrEqualTo(Date value) {
            addCriterion("certificate_gmt_modified >=", value, "certificateGmtModified");
            return (Criteria) this;
        }

        public Criteria andCertificateGmtModifiedLessThan(Date value) {
            addCriterion("certificate_gmt_modified <", value, "certificateGmtModified");
            return (Criteria) this;
        }

        public Criteria andCertificateGmtModifiedLessThanOrEqualTo(Date value) {
            addCriterion("certificate_gmt_modified <=", value, "certificateGmtModified");
            return (Criteria) this;
        }

        public Criteria andCertificateGmtModifiedIn(List<Date> values) {
            addCriterion("certificate_gmt_modified in", values, "certificateGmtModified");
            return (Criteria) this;
        }

        public Criteria andCertificateGmtModifiedNotIn(List<Date> values) {
            addCriterion("certificate_gmt_modified not in", values, "certificateGmtModified");
            return (Criteria) this;
        }

        public Criteria andCertificateGmtModifiedBetween(Date value1, Date value2) {
            addCriterion("certificate_gmt_modified between", value1, value2, "certificateGmtModified");
            return (Criteria) this;
        }

        public Criteria andCertificateGmtModifiedNotBetween(Date value1, Date value2) {
            addCriterion("certificate_gmt_modified not between", value1, value2, "certificateGmtModified");
            return (Criteria) this;
        }

        public Criteria andStuIdIsNull() {
            addCriterion("stu_id is null");
            return (Criteria) this;
        }

        public Criteria andStuIdIsNotNull() {
            addCriterion("stu_id is not null");
            return (Criteria) this;
        }

        public Criteria andStuIdEqualTo(Integer value) {
            addCriterion("stu_id =", value, "stuId");
            return (Criteria) this;
        }

        public Criteria andStuIdNotEqualTo(Integer value) {
            addCriterion("stu_id <>", value, "stuId");
            return (Criteria) this;
        }

        public Criteria andStuIdGreaterThan(Integer value) {
            addCriterion("stu_id >", value, "stuId");
            return (Criteria) this;
        }

        public Criteria andStuIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("stu_id >=", value, "stuId");
            return (Criteria) this;
        }

        public Criteria andStuIdLessThan(Integer value) {
            addCriterion("stu_id <", value, "stuId");
            return (Criteria) this;
        }

        public Criteria andStuIdLessThanOrEqualTo(Integer value) {
            addCriterion("stu_id <=", value, "stuId");
            return (Criteria) this;
        }

        public Criteria andStuIdIn(List<Integer> values) {
            addCriterion("stu_id in", values, "stuId");
            return (Criteria) this;
        }

        public Criteria andStuIdNotIn(List<Integer> values) {
            addCriterion("stu_id not in", values, "stuId");
            return (Criteria) this;
        }

        public Criteria andStuIdBetween(Integer value1, Integer value2) {
            addCriterion("stu_id between", value1, value2, "stuId");
            return (Criteria) this;
        }

        public Criteria andStuIdNotBetween(Integer value1, Integer value2) {
            addCriterion("stu_id not between", value1, value2, "stuId");
            return (Criteria) this;
        }

        public Criteria andCertificateIsDelIsNull() {
            addCriterion("certificate_is_del is null");
            return (Criteria) this;
        }

        public Criteria andCertificateIsDelIsNotNull() {
            addCriterion("certificate_is_del is not null");
            return (Criteria) this;
        }

        public Criteria andCertificateIsDelEqualTo(Integer value) {
            addCriterion("certificate_is_del =", value, "certificateIsDel");
            return (Criteria) this;
        }

        public Criteria andCertificateIsDelNotEqualTo(Integer value) {
            addCriterion("certificate_is_del <>", value, "certificateIsDel");
            return (Criteria) this;
        }

        public Criteria andCertificateIsDelGreaterThan(Integer value) {
            addCriterion("certificate_is_del >", value, "certificateIsDel");
            return (Criteria) this;
        }

        public Criteria andCertificateIsDelGreaterThanOrEqualTo(Integer value) {
            addCriterion("certificate_is_del >=", value, "certificateIsDel");
            return (Criteria) this;
        }

        public Criteria andCertificateIsDelLessThan(Integer value) {
            addCriterion("certificate_is_del <", value, "certificateIsDel");
            return (Criteria) this;
        }

        public Criteria andCertificateIsDelLessThanOrEqualTo(Integer value) {
            addCriterion("certificate_is_del <=", value, "certificateIsDel");
            return (Criteria) this;
        }

        public Criteria andCertificateIsDelIn(List<Integer> values) {
            addCriterion("certificate_is_del in", values, "certificateIsDel");
            return (Criteria) this;
        }

        public Criteria andCertificateIsDelNotIn(List<Integer> values) {
            addCriterion("certificate_is_del not in", values, "certificateIsDel");
            return (Criteria) this;
        }

        public Criteria andCertificateIsDelBetween(Integer value1, Integer value2) {
            addCriterion("certificate_is_del between", value1, value2, "certificateIsDel");
            return (Criteria) this;
        }

        public Criteria andCertificateIsDelNotBetween(Integer value1, Integer value2) {
            addCriterion("certificate_is_del not between", value1, value2, "certificateIsDel");
            return (Criteria) this;
        }

        public Criteria andCertificateStuScoreIsNull() {
            addCriterion("certificate_stu_score is null");
            return (Criteria) this;
        }

        public Criteria andCertificateStuScoreIsNotNull() {
            addCriterion("certificate_stu_score is not null");
            return (Criteria) this;
        }

        public Criteria andCertificateStuScoreEqualTo(Double value) {
            addCriterion("certificate_stu_score =", value, "certificateStuScore");
            return (Criteria) this;
        }

        public Criteria andCertificateStuScoreNotEqualTo(Double value) {
            addCriterion("certificate_stu_score <>", value, "certificateStuScore");
            return (Criteria) this;
        }

        public Criteria andCertificateStuScoreGreaterThan(Double value) {
            addCriterion("certificate_stu_score >", value, "certificateStuScore");
            return (Criteria) this;
        }

        public Criteria andCertificateStuScoreGreaterThanOrEqualTo(Double value) {
            addCriterion("certificate_stu_score >=", value, "certificateStuScore");
            return (Criteria) this;
        }

        public Criteria andCertificateStuScoreLessThan(Double value) {
            addCriterion("certificate_stu_score <", value, "certificateStuScore");
            return (Criteria) this;
        }

        public Criteria andCertificateStuScoreLessThanOrEqualTo(Double value) {
            addCriterion("certificate_stu_score <=", value, "certificateStuScore");
            return (Criteria) this;
        }

        public Criteria andCertificateStuScoreIn(List<Double> values) {
            addCriterion("certificate_stu_score in", values, "certificateStuScore");
            return (Criteria) this;
        }

        public Criteria andCertificateStuScoreNotIn(List<Double> values) {
            addCriterion("certificate_stu_score not in", values, "certificateStuScore");
            return (Criteria) this;
        }

        public Criteria andCertificateStuScoreBetween(Double value1, Double value2) {
            addCriterion("certificate_stu_score between", value1, value2, "certificateStuScore");
            return (Criteria) this;
        }

        public Criteria andCertificateStuScoreNotBetween(Double value1, Double value2) {
            addCriterion("certificate_stu_score not between", value1, value2, "certificateStuScore");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}